|
|
Database System Analysis and Implementation
Třetina, Jan ; Ráb, Jaroslav (referee) ; Zendulka, Jaroslav (advisor)
With the increase of demands for the speed and availability of the information technologies, the process of optimization gains more and more importance. Concerning search engine optimization, optimization of operating systems or application optimization (source code), the goal is to gain faster, smaller and more maintainable solution. In my thesis I deal with optimization of database systems, which includes low level of database tuning - physical organization of data and indices, database management system tuning and query optimization. I focused on optimization of Microsoft SQL Servers 2005 in enterprise environment.
|
|
|
Advanced Oracle Database Monitoring Tool
Mikulka, David ; Chmelař, Petr (referee) ; Kolář, Dušan (advisor)
This master's thesis describes possibilities of Oracle Database 10g and 11g monitoring. It let the reader know about practical tools for monitoring and describes the database's internal catalogs preserving statistics and the information about running database instances within history. Next, it describes design of an Oracle database monitoring tool, describtion of its implementation and at the end its evaluation and comparison with other similar applications.
|
|
|
Test form Data Processing System
Purdjak, Jakub ; Ščuglík, František (referee) ; Ráb, Jaroslav (advisor)
The aim of this bachelor work is to develope the test form data processing system with the aid of relational database Oracle and environment Oracle Apex. The work analyses requirements of creating and processing test forms. It describes design and implementation of target system.
|
|
|
Advanced Oracle Database Monitoring Tool
Mikulka, David ; Chmelař, Petr (referee) ; Kolář, Dušan (advisor)
This master's thesis describes possibilities of Oracle Database 10g and 11g monitoring. It let the reader know about practical tools for monitoring and describes the database's internal catalogs preserving statistics and the information about running database instances within history. Next, it describes design of an Oracle database monitoring tool, describtion of its implementation and at the end its evaluation and comparison with other similar applications.
|
|
| |
|
|
Database System Analysis and Implementation
Třetina, Jan ; Ráb, Jaroslav (referee) ; Zendulka, Jaroslav (advisor)
With the increase of demands for the speed and availability of the information technologies, the process of optimization gains more and more importance. Concerning search engine optimization, optimization of operating systems or application optimization (source code), the goal is to gain faster, smaller and more maintainable solution. In my thesis I deal with optimization of database systems, which includes low level of database tuning - physical organization of data and indices, database management system tuning and query optimization. I focused on optimization of Microsoft SQL Servers 2005 in enterprise environment.
|
|
|
XML Representation of Network Traffic
Novák, Martin ; Ščuglík, František (referee) ; Ráb, Jaroslav (advisor)
This bachelor work deals with the representation of captured network traffic in XML and storing within a database system Oracle by using XML schema. The beginning explains the basics of computer networks, network management and network protocols that are captured. Followed by chapters on network traffic analyzer, NetPDL format used to describe intercepted traffic, a chapter devoted to the foundation of relational database systems and the foundation of Oracle database system. At the end of the bachelor work there are chapters dealing with the created XML schemas, implementation of the program, program tools and the description how to use the program.
|
|
|
The ways of comparing performance of Oracle databases
Mareček, Aleš ; Chlapek, Dušan (advisor) ; Macák, Petr (referee)
This thesis examines ways of comparing performance of Oracle databases. The need to compare performance is given by making changes in database systems, for example changes in databases structures or database management systems. One of the goals of this thesis includes a description of options and ways of comparing performance of Oracle databases which does not involve any additional licensing costs. Because there is a need to evaluate obtained performance indicators, part of this thesis deals with the design and implementation tool, which allows analysis of data and their evaluation through defined reports. Functionality of the tool is verified and demonstrated on data obtained from real databases. The main contribution of this thesis is the implementation of the tool, which significantly facilitate evaluating performance impact of changes which should be made in the production database.
|
|
|
Impact of partitioning on the performance of Oracle database
Řeháček, Tomáš ; Macák, Petr (advisor) ; Palovská, Helena (referee)
The main aim of this bachelor thesis is to provide information about how to use partitioning in an Oracle database and to determine its effect on change in performance during database load. Description of this additional functionality and proposal appropriate testing environment in which it is possible to make measurements were necessary in order to achieve the main goal. The contribution is in the recommendations that can be drawn on the basis of the values obtained during tests performed. The thesis examines general options of partitioning, benefits and costs that are associated with its use, application partitioning methods and management capabilities. Tests are conducted on a large number of scenarios in the practical part. Conclusions, recommendation and suitable conditions for use of partitioning are based on tests.
|
|
|
Technologies for storing and processing of extremely large volumes of data in the ORACLE
Spurný, Petr ; Macák, Petr (advisor) ; Krch, David (referee)
The aim of the Bachelor's thesis is to provide an overview and description of such technologies in the Oracle database, which can be used for work with extremely large volumes of data and to verify the benefits of some of these technologies in practice. At the beginning, the work deals with problems of large amounts of data in general and seeks to define the size of data in the database systems. In the theoretical part, several different technologies will be introduced. The greatest emphasis is placed on various forms of partitioning. The practical part contains a proposal for the implementation of tests, building automated test procedures, and for the execution of these tests. The work can be used as a quick guide in case of dealing with performance issues with large volumes of data. Making any changes for the particular case is easy according to examples given in the text. Last, but not least, the work may help with automatic testing procedures, which can be used with a slight adjustment for a wide range of test cases.
|
guest ::
